﻿-- --------------------------------------------------
-- Creating all FOREIGN KEY constraints
-- --------------------------------------------------

-- Creating foreign key on [Flight_FlightNr] in table 'PassengerSet'
ALTER TABLE [dbo].[PassengerSet]
ADD CONSTRAINT [FK_FlightPassenger]
    FOREIGN KEY ([Flight_FlightNr])
    REFERENCES [dbo].[FlightSet]
        ([FlightNr])
    ON DELETE NO ACTION ON UPDATE NO ACTION;


